MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (
  word varchar(50)
);

insert into test (word) values
('Ab'),
('Zo'),
('Ac'),
('Št'),
('Ád'),
('Ae'),
('Áf'),
('Ba'),
('Ca'),
('Žv');

select * from test;

word

Ab

Zo

Ac

Št

Ád

Ae

Áf

Ba

Ca

Žv

select * from test
order by convert(word using utf8mb4) collate utf8mb4_icelandic_ci;

word

Ab

Ac

Ae

Ád

Áf

Ba

Ca

Št

Zo

Žv

CREATE PROCEDURE `Try_Collation`()
BEGIN

DECLARE v_finished INTEGER DEFAULT 0;
DECLARE c_collation varchar(100) DEFAULT "";

-- read available collations for utf8mb4
DECLARE table_cursor CURSOR FOR 
	SELECT COLLATION_NAME 
    FROM INFORMATION_SCHEMA.COLLATIONS
    WHERE CHARACTER_SET_NAME='utf8mb4';

DECLARE CONTINUE HANDLER 
    FOR NOT FOUND SET v_finished = 1;

OPEN table_cursor;

	Loop_label: LOOP -- test individual collations by loop

    -- read one collation to table_cursor
	FETCH table_cursor INTO c_collation;

	IF v_finished = 1 THEN 
		LEAVE Loop_label;
	END IF;
	
    -- a temp table for the currently ordered result
	DROP TEMPORARY TABLE IF EXISTS temp_table;
	CREATE TEMPORARY TABLE temp_table (
        `word` varchar(50)
        );

    SET @s=CONCAT(
        "INSERT INTO temp_table ",
        "(select word from test ",
        "order by convert(word using utf8mb4) ",
        "collate ",c_collation,");");
	
	PREPARE stmt FROM @s;
	EXECUTE stmt;
	DEALLOCATE PREPARE stmt;
	
	-- set some filtering rules for checking orders
	IF (select word from temp_table limit 2,1)='Ád' THEN
		ITERATE Loop_label; -- skip to next loop iteration
	END IF;
    IF (select word from temp_table limit 5,1)='Zo' THEN
		ITERATE Loop_label; -- skip to next loop iteration
	END IF;
	
	SELECT c_collation; -- print out current collation
	SELECT * FROM temp_table; -- print out ordered table

	END LOOP Loop_label;

CLOSE table_cursor;

END;

CALL Try_Collation();

c_collation

utf8mb4_icelandic_ci

word

Ab

Ac

Ae

Ád

Áf

Ba

Ca

Št

Zo

Žv

c_collation

utf8mb4_is_0900_ai_ci

word

Ab

Ac

Ae

Ád

Áf

Ba

Ca

Št

Zo

Žv

c_collation

utf8mb4_is_0900_as_cs

word

Ab

Ac

Ae

Ád

Áf

Ba

Ca

Št

Zo

Žv