As long as needed, it will be 'reviewed regularly'. Basically til whenever the local caseload and growth rate is low enough to be moved down a tier.
As I've mentioned before, there are several areas with significantly lower metrics than Glasgow that are also on Tier 3 (such as Edinburgh), so don't expect that to happen any time soon.