Auto Rotation Table

Is there any strcuture or fucntion that can make the table have something like rotation.

I mean the record can be first in first delete.

So,for example , even the table have limit row for example , 100 row .

so, the new data can be replace the oldest row in the table auto and insert into the table .

so the new row will replace the oldest 99 th row auto .the table still keep 100 row but the data can be update .

Is it "partition" or other ??

how can I create it .