Horizon corrects the wrong orientation regardless of the translation/position of the device. Small translation differences along the X or Y axis can be corrected by the stabilisation algorithm. Large translation deltas, however, cannot be corrected.

So, if you put the iPhone on the outer part of the wheel you will most probably get a horizontal video that will end up showing your scene moving up-down, left-right.