A sex video has ended French ruling party candidate Benjamin Griveaux's hopes of becoming mayor of Paris.