No, the p950 won’t auto focus bracket, it’ll just auto bracket for exposure. To my knowledge, Nikon doesn’t offer a camera as of yet that will auto focus
stack, just auto focus bracket. There are some (including my z6 and all other mirrorless, but maybe not the z30) that will auto focus bracket shots for you but the stack is up to you to complete while post processing, that is it will take a series of shots for you adjusting focus automatically in camera at adjustment parameters you set in camera but will not merge the stack for you in camera, you’ll have to do that on the computer or tablet using something like photoshop or similar. There are other options though. As
@Fred Kingston mentioned, theres the CamRanger 2 that I used with my D7500 & D800 for macro shots. I just hated the cord and the process of tethering. It works but it’s cumbersome. There’s also macro rails you can get on the cheap to very expensive if you want to do the adjusting manually. Just plant the rails on the tripod, focus close, take a shot and then twist the dial on the rail slightly to move the focus further away slightly and repeat. Do this a buncha times, (hundreds for some macro shots) and you’ll end up with a focus bracket you can stack in post. Also, it depends what you’re trying to stack. If it’s a landscape, its easy enough to plant your camera on the tripod and choose 3-5 focus points near to far for 3-5 shots that you merge in PS. No need for any special gear. I like the process in the z6 better than the camranger2 and much better than the rails, I haven’t used either since going mirrorless.