I want put LIMIT and ORDER, in following query. how is it?

PHP Code:
ORDER BY tour_foreign.id asc
LIMIT $offset
$coun_page 
In the this query:

PHP Code:
SELECT
               
@rownum := @rownum 1 rownum,
               
tour_foreign.id
               
tour_foreign.name,
               
tour_foreign.airline,
               
MIN(tour_foreign_residence.name_re) AS name_re
               
tour_foreign.service
               
tour_foreign.date_go
               
tour_foreign.date_back
               
tour_foreign.term,
               
tour_foreign.useradmin_submit,
               
tour_foreign.date_submit,
               
GROUP_CONCATtour_foreign_residence.name_re 
                     ORDER BY tour_foreign_residence
.name_re 
                     SEPARATOR 
'، '
                   
) AS name_re_all
            FROM   tour_foreign 
              INNER JOIN tour_foreign_residence 
            ON 
tour_foreign.id tour_foreign_residence.relation )
              
JOIN (SELECT @rownum := 0r
            GROUP BY  tour_foreign
.id            
            HAVING name LIKE 
'%" . $find . "%'
            
OR     airline LIKE '%" . $find . "%'
            
OR     name_re_all LIKE '%" . $find . "%'
            
OR     service LIKE '%" . $find . "%'
            
OR     date_go LIKE '%" . $find . "%'
            
OR     date_back LIKE '%" . $find . "%'
            
OR     term LIKE '%" . $find . "%'
            
OR     useradmin_submit LIKE '%" . $find . "%'
            
OR     date_submit LIKE '%" . $find . "%'