As the fashion photographer opens a new exhibition in London, Jimmy Moffat, a founder of the agency who signed him, shares the stories behind his most iconic work