Firms miss out as Manchester wins race for super-casino