WP Query order by alphanumeric meta value

natural_sort_alphanums.php

<?php
function orderbyReplace($orderby)
{
    global $wpdb;
    // use this if you have stable literal prefixes (e.g. af102, af56, af2569)
    $new = str_replace($wpdb->prefix . 'postmeta.meta_value ASC', 'LENGTH(mt1.meta_value) ASC, mt1.meta_value ASC', $orderby);
    // use this if you have something like (102bch, 56dbg, 2569, 12ea)
    $new = str_replace($wpdb->prefix . 'postmeta.meta_value ASC', 'CAST(mt1.meta_value as UNSIGNED) ASC, mt1.meta_value ASC', $orderby);
    return $new;
}

$args = [
    'post_type' => 'mycpt',
    'order' => 'ASC',
    'posts_per_page' => -1,
    'meta_key' => 'my-meta-key',
    'orderby' => 'meta_value',
    'meta_query' => [
        [
            'key' => 'my-meta-key',
            'value' => '',
            'compare' => 'LIKE'
        ],
    ]
];

add_filter('posts_orderby', 'orderbyReplace');
$q = new WP_Query($args);
remove_filter('posts_orderby', 'orderbyReplace');