Glasgow has been confirmed as the host of the 2026 Commonwealth Games.