This is definitely not melodic rock, but it was a big college rock and top 30 hit during '88...
The Church - Under The Milky Way
I want to say that Rod Stewart had one that qualifies. It's been a while since I've heard the studio version, but I remember the music video for his early 80's remake of "All Right Now" had a bagpipe ensemble marching into the arena at the beginning. Per
Forum:
Noticeboard