table + primary key

create table au_clients (
        id          numeric(10,0)  not null,
        name        varchar(255)   not null,
		constraint au_clients_pk primary key (id))

go

i want that id is filled automatically. How to do it?