It seems to me that there's no value in retaining a retired item in the database if a new item with the same id is created.

Such a create operation would actually edit the existing retired item (and unretire it).

Thus a unique index on id would be appropriate.