The singer-songwriter reflects on his career, which began in the 1960s and saw him collaborate with artists such as the Beatles and Jimmy Page