Music legend Sir Rod Stewart, who is set to headline Glastonbury Festival's Pyramid stage this weekend for the Legends set, made a shock revelation about retiring from music