David Paton's 50-year-old hit song "Magic" earned him $1 million from use in Ozempic commercials, illustrating the value of a musician's back catalog.