SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...