Help with :limit :ofset loop?

This is the code in my model to display 10 records from a db table at
a time.

def self.find_5
find(:all,
:order => ‘id’,
:limit => 5, :offset => 0)
end

I want to make a loop so that say if my table contains 45 records and
the limit is find 5 records and the offset changes on a weekly basis
and one day overlaps my last record it will continue and pull from the
first record and so on.

Thank you for reading.