The Scottish Government have confirmed that they will back Glasgow's bid to host a scaled-down version of the Commonwealth Games in 2026.