How to Paginate a MySql Ranking Query
Here

FROM teams p
, (SELECT @curRank := 0) r 


you are resetting the value for @curRank to 0 every time you execute the query. Make this dynamic as well, adjust it according to your LIMIT clause.

On the second run change it to 

FROM teams p
, (SELECT @curRank := 25) r