Minibatch vs Local SGD with Shuffling: Tight Convergence Bounds and Beyond