Limit number of records in a table in SQLite

I want to implement in SQLite a table that stores up to 100 records.

The behavior that I am looking for is that the table stores records and when it is full and a new record is added, it deletes the oldest record and writes the new one.

I was reading through the SQLite documentation but I don't find what I am looking for.

Any ideas?