Hello and thanks for using AQL!
Menu Order is an available sorting option in AQL. However, posts don’t support setting the order. To do that you will need to update the post type so that is supports page-attributes.
See this Stack Overflow question for an example.
Thanks. I had already added page-attributes to post with this small plugin:
<?php /* Plugin Name: My Post Page Attributes */
add_action( 'init', function() { add_post_type_support( 'post', 'page-attributes' ); });
The actual problem seems to have been that in your block I used Settings > Query Type > Custom and there did use Order by > Ascending by order and also clicked around in various other options in block sidebar e.g. at Advanced Query Settings > Post Order by > Menu Order with extra switch Ascending Order there and more. The two order settings obviously affect each other.
When the post order in frontend did not change with my tests, I thought I would do something wrong and asked above question.
I think something was messed up with different / contradicting settings in same block as later also the block caused an error in block editor when I tried to re-open it.
Created a new page with a new Query Type > Custom block from scratch and only changed the order option this time and it seems to work now.
