select last week values from table in MYSQL

select `order_id` from `order` where date between date_sub(now(),INTERVAL 1 WEEK) and now();