Yes - "To sit in front" ís not correct and means to be outside the bus.
I like to sit up front when taking the bus/when I travel by bus
I like to sit at the front....
Sit in the front row - refers to somewhere with line of seats like a cinema
Hope that helps
- For Teachers