The most fitting response to the question about the effect of starting in the middle of a story's action is: "It pulls the reader right into the excitement of the story."
Starting in the middle of the action, often referred to as in media res, effectively grabs the reader's attention and immediately immerses them in the plot.