SQLite Insert with the newly generated id

SQLite Insert with the newly generated id

I have a table with an auto increment field and another field VARCHAR
filed. I would like to fill the string field with the newly generated id
directly in the insert query. For example with table:
Person
(
id auto_increment,
name varchar
)
I would like to perform a query like this:
INSERT INTO Person(name) VALUE ('Person #' + ROWID())
Anyway to do this?