Four of the rainiest UK cities revealed to be in Scotland