John Swinney has signed off plans for Glasgow to host a stripped-down Commonwealth Games.