Prolific session musician also played on albums by David Bowie (including his hits “Space Oddity” and “Rebel Rebel”), Elton John, Harry Nilsson and three solo Beatles