Claudio Ranieri could not hide his emotions as Cagliari secured Serie A return with last-minute goal