Decision dashes hopes of cities such as Dundee and Leeds, which were preparing bids costing hundreds of thousands of pounds