How to auto increment with character + integer?

Question

I have created a table and with a primary key called "ID". However, I want the "ID" be auto increment as well. Here is my question, how can I do in the following format: "Air0001", "Air0002", "Air0003", ............ etc.