It's more than likely the song 'Final Fantasy', also commonly titled 'Prologue'. It plays in almost all of the main numbered Final Fantasies, so it's no surprise if you've heard it before.

And it is a wonderful tune.