Intensity and source state dependence of the quasi-periodic oscillations in Scorpius X-1