cloud/bmaa/reflection: add ORDER BY machine_id

Change-Id: Icfaf0f21ac4a1591c73a5fd3cc3d4a2cac01a8f6
Reviewed-on: https://review.monogon.dev/c/monogon/+/1550
Tested-by: Jenkins CI
Reviewed-by: Serge Bazanski <serge@monogon.tech>
diff --git a/cloud/bmaas/bmdb/reflection/reflection.go b/cloud/bmaas/bmdb/reflection/reflection.go
index 6a45d27..ebebed1 100644
--- a/cloud/bmaas/bmdb/reflection/reflection.go
+++ b/cloud/bmaas/bmdb/reflection/reflection.go
@@ -111,6 +111,7 @@
 		q = append(q, "WHERE machines.machine_id = $1")
 		args = append(args, *opts.FilterMachine)
 	}
+	q = append(q, "ORDER BY machines.machine_id")
 
 	rows, err := r.db.QueryContext(ctx, strings.Join(q, "\n"), args...)
 	if err != nil {