For some people, the thought of their partner being with someone else is a nightmare; for others, it can be a surprisingly powerful source of arousal.