In a freewheeling, often revealing conversation, the Scottish singer-songwriter and Rock Hall inductee talks about his first big hit of the psychedelic era