Comparison of multi-band period-luminosity relations for classical Cepheids in the Magellanic Clouds