Integral field spectroscopy of nearby quasi-stellar objects - II. Molecular gas content and conditions for star formation