The former Allman Brothers pianist and honorary Rolling Stone talks to Kevin E G Perry about inadvertently giving ‘Top Gear’ its theme tune, celebrating 40 years with the world’s greatest rock’n’roll band, and the ‘big loss’ of Charlie Watts