如何按行对数据进行排序?[MYSQL]

Question

我的数据库

create_by//tr><1>

id	title
1	aaa	2
2	bbb
3	ccc	3
4	ddd	2
5	eee	2
6	fff	3

WITH cte AS ( SELECT id,
title,
create_by,
COUNT(create_by) OVER (PARTITION BY create_by) cnt
FROM src_table )
SELECT id,
title,
create_by
FROM cte
ORDER BY cnt, id;