Red is the new black: how the colour of urban skyglow varies with cloud cover