getting the current value of an auto-incrementing ID

Question

I have a table with an with a key column with the name id declared as an auto-number so that it automatically increments when I insert a record to the table. What Select statement can I run to determine what the current (last) value of id is?