You can use the below query directly if you are using the latest version as it Microsoft implemented STRING_SPLIT() built-in function which converts a string into rows as per the...

I think with the below query the desired result can be achieved.

select b1.Name,b1.SuggestedName
from (
    select *, row_number() over(order by name)as 'slno'
    From Bikes )as b1