The story
Wordplay on the idea that the person having the orgasm is saying "oh!" and their mouth is O-shaped while they're saying it. It has also sometimes been claimed that the letter o stands for the word orgasm.
Etymology from Wiktionary, CC BY-SA 4.0.