Hi Cha,
Any bottle you like as long as you respect its pressure tolerances. Therein is the challenge. Ideally you need a reliable method that delivers a predictable end point to the fermentation in the final bottle. However, when making your first batch it is unlikely you will have that reliable method.
So, as like most of us you don't know what the heck is the point it will stop fermenting then put it in a bottle that can control its pressure - these include the swing top bottles that can release excess pressure.
The professionals carefully get a completely dry base wine with an SG of about 0.990 then add a controlled amount of sugar, with fresh active yeast and and nutrient and stable temperature. It goes dry again and they finally decant off the yeast, put in a small amount of sweetener and probably a bit of sulphide to inhibit any residual yeast and get a controlled pressure and sweetness.