Именно через group_concat() нельзя. Но можно через GROUP N BY и WITHIN GROUP ORDER BY :
snikolaev@dev:~$ docker run --name manticore --rm -d manticoresearch/manticore && docker exec -it manticore mysql && docker stop manticore
1277f54736f7d9b708d9ff5f3a0961cb37a8e2641059f3758c9eb860758ee878
mysql> create table t(f text, group_id int);
mysql> insert into t values(28964,'a',114);
mysql> insert into t values(29216,'a',114);
mysql> select id, groupby() as `group_id` from t where group_id = 114 group 2 by `group_id` within group order by id asc;
+-------+----------+
| id | group_id |
+-------+----------+
| 28964 | 114 |
| 29216 | 114 |
+-------+----------+
mysql> select id, groupby() as `group_id` from t where group_id = 114 group 2 by `group_id` within group order by id desc;
+-------+----------+
| id | group_id |
+-------+----------+
| 29216 | 114 |
| 28964 | 114 |
+-------+----------+
На group_concat() WITHIN GROUP ORDER BY, к сожалению, не действует:
mysql> select group_concat(id) as `ids`, groupby() as `group_id` from t where group_id = 114 group by `group_id` within group order by id asc;
+-------------+----------+
| ids | group_id |
+-------------+----------+
| 29216,28964 | 114 |
+-------------+----------+
mysql> select group_concat(id) as `ids`, groupby() as `group_id` from t where group_id = 114 group by `group_id` within group order by id desc;
+-------------+----------+
| ids | group_id |
+-------------+----------+
| 29216,28964 | 114 |
+-------------+----------+
Хотя теоретически это было бы полезно в плане функционала (либо же сделать отдельный ORDER BY, как в MySQL), но пока такого функционала нет.