How to split a row into many equals rows by a value in a column in MySql?

Question

MySQL Sample Order Table (Click to see the table):

MySQL Order Table

I search everywhere however unable to find some MySQL syntax/query to get the below result. MySQL query result needed(Click to see the result table):

MySQL query needed result

Looking for MySQL query which will provide the above result.