What happens if you go over the threshold MAU limit of a certain Tier?
The server will be locked if you go over the threshold MAU limit. You can login but no data will be visible.
Does the Tier gets upgraded automatically and the billing occurs on the basis of the upgraded Tier?
No, the tier related to the server does not get upgraded automatically.