Characterising CO excitation in quasar host galaxiesÂ