They can upgrade you to the next category of room up, but if there is a room two categories up, they can ask you to pay.

In my experience, hotels will try to upgrade you to the best available room (no matter how many categories, not including suite), but this will vary depending on location, how busy they are, attitude of front desk staff etc