When ANY car's engine is off, there are effectively no foot brakes as the servo system relies on vacuum created by the engine to reduce the amount of pressure you have to apply to get the brakes to work.
It doesn't matter whether you are in a stick or auto.
Advice.
Stick the car in PARK, then shut it off. Everytime.