how to give limit and offset in mysql code example

Example: limit offset order by mysql

SELECT 
    column_list
FROM
    table1
ORDER BY column_list
LIMIT row_count OFFSET offset;