The world’s 100 most populated cities are becoming increasingly exposed to floods and droughts, new research has found.