do we get results in random order for select * from table in postgres code example

Example: postgres random select

select * from app_product order by random() limit 10;