title: laravel paginate a query that has a limit clause
body: <p>You have a database of 10,000 customers.  You want to limit your search to only 500 of those customers but want to paginate the results by 50 results each page.  So the last page, page 10, of the results would have 50 results.  There would be no page 11.</p>
  
  <p>Is this possible with eloquent/laravel?  Something like "select * from people order by field desc limit 500" and then perform pagination on those results?</p>
  
  <p>Paginate seems to use ->take() and ->offset(), which ignore ->limit().  I'd like to be able to use all three.</p>