Big things are happening on TV Tropes! New admins, new designs, fewer ads, mobile versions, beta testing opportunities, thematic discovery engine, fun trope tools and toys, and much more - Learn how to help here and discuss here.
That song was created and played by Tak Matsumoto, the guitarist of the most successful band in Japan, B'z. The guy has been considered by many to be a genius guitarist and the song certainly showed it. B'z itself would later sing the theme song to the 2007 Raoh Den movie, LONELY STARS, which is very awesome as well. Here's the live version 
The French opening needs a mention. It can't compete with YOU WA SHOCK, but it's still audible, quite upbeat, and manly as well. And this is an amazing achievement when we make a comparison with all the anime from that time who got a new, and in 99% of cases craptastic, opening.