Do you have to play Sonic the Hedgehog games in numerical order to understand the story

Nope!
The characters talk about the story a little during the games. Some games have they're own story instead of following and old one.