Shift in weather patterns also sees cities such as Madrid and Hong Kong flip from wet to dry