A characterisation of common diagonal stability over cones