How to order posts by alphabet with numbers at the end

With some help of this answer and this post I managed to get your desired sorting hooking into the posts_orderby filter.

You would need to add some additional check so this only affects your post type and on your page of choice but this snippet gives you the required statement to get the

Apple store
Zebra store
7-11

posts sorting, provided their slug is

apple-store
zebra-store
7-11

since I order by post_name which is the post’s slug

add_filter( 'posts_orderby' , 'wpse_custom_orderby_statement' );
function wpse_custom_orderby_statement( $orderby ) {

  $orderby = " post_name+0<>0 ASC, post_name+0, post_name";

  return $orderby;
}

error code: 523