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.