“I knew it was a better song than I’d written up to that point. I’d turned a corner as a songwriter. But in terms of thinking it was a hit, I had no idea”: How a pilgrimage to the crucible of rock ’n’ roll inspired the ’90s classic Walking In Memphis