The text implies that the sexual activity was so intense or loud that it metaphorically satisfied not just the participants but also the neighbors, as if they had participated and needed a cigarette, which is a common trope for relaxation after sex. It does not rely on different meanings of a word or similar-sounding words for humor.
Last night sex was so good the neighbors lit cigarettes .