Wow, lot's of generations in the mix.
#1 for me (when sober) is "Stand by Me".
Otherwise it would be "You Sexy Thing/Thang" by Hot Chocolate, I think (not very good @ remembering song titles & bands). The lead in is: "I believe in miracles", in the event that I have the title wrong.
"Ghost Riders in the Sky", by Miss Peggy Lee, always makes me horny, but this is not up for further discussion. LOL!
I am also a BIG Jacques Brel fan, but the name of any preferred title escapes me, being language impaired, and I am too lazy to go through our LP's.
Another great sentimental song (other than "As Time Goes By") is the orchestrated music to "Over the Rainbow" (lots of things going on, for the masses (I think) with this tune).