Is it possible to retrieve rows based on 2 columns and have rows reoccur?

For example:

`id` `Start` `Finish`
 0     1        5
 1     2        9
 2     6        8

And then querying to get each row ordered by both start and finish getting reoccurences like so

`id` `Start` `Finish`
 0     1        5
 1     2        6
 0     1        5
 2     6        8
 2     6        8
 1     2        9

I get 0 first because its start=1. Then 1 because start=2. Then 0 again because finish=5 followed by 2 because start=6 and so on...

No necessarily asking for logic on how to do this, just if it's possible and if you could point me in the right direction :)