From the answers in the comments:
1. In order to concatenate unique values with group by clause: group_concat(distinct Locality)
2. Data ordering (by the data sample link from comment): From your data, it looks like that the start/End chainage fields are connected with the direction & order so this looks the most promising sql (see image): ...