The Scottish government has backed a bid for Glasgow to host a scaled-down version of the Commonwealth Games in 2026, 12 years after the city last hosted the quadrennial multi-sport event.