I have around 1320 point/centroid features in a shapefile for my research plots. Each point/centroid has X and Y coordinate associated with them which were calculated using Field Calculator > Geometry > $X $Y in QGIS. At present the reference IDs are in no particular order. But eventually I would like to create a new attribute column by the order shown in the below image. .
At first I tried to sort my points by X and Y (selecting 10 consecutive points at a time) but due to fact that all points in a single row don't lie on the same northing or easting line, the plot order was not proper.
So I would like to know if there is a neat way to sort these points spatially (X and Y) and then assign a sequence ID in the order as shown in the image.