Kuala Lumpur and Mumbai were the cheapest places for a weekend holiday while Sydney was the most expensive