I have a weekly timeline on mysql wherein I sort activities by time using the built-in `ORDER BY` function: `ORDER BY time`.

Actual result
-------------

```
00:01
07:00
08:00
11:00
23:00

```

Expected result
---------------

```
07:00
08:00
11:00
23:00
00:01
01:00
04:00

```

etc., 'til 07:00 (e.g., modulus 7 a.m.).

How can I change the format?