“I don’t have many rock’n’roll stories for you – that was always someone else’s job”: Phil Collins was pranked by George Harrison, outdrunk by John Martyn, blown away by Robert Fripp and well-behaved with Eric Clapton