Collective nature of spin excitations in superconducting cuprates probed by resonant inelastic X-Ray scattering