Yeah, pretty sure most games back then were released only physically on PC. Steam didn't take off for a few years afaik.
Personally, I use this drive: https://www.amazon.co.uk/gp/product/B07G15WKWX/ref=ppx_yo_dt_b_asin_title_o09_s00?ie=UTF8&psc=1
That's the UK store and it's currently not available there, but if my drive is anything to go by, it's a decent drive you should look into if you want one, although it doesn't have a very long cable so you have to keep it real close to the slot it's in.
"NintenDON'T sue me please haha"
It was only released on disc, right? I have it on disc along with a ton of old PC games that never got digital releases like Black & White 2, but I don't have a disk drive. Thought about getting an external one just because I don't wanna go through the trouble of bay expansion when I'd only use it for a handful of games and burning cds now and then.