Following the success of the Commonwealth Games in Manchester, other cities are looking to bid for future sporting events.