PPI describes how many image pixels are spread across each inch of paper when a digital file is printed. A file has a fixed pixel count; its PPI changes with the size you print it at. A 3000 × 2000 pixel photo is 300 ppi at 10 × 6.67 in and 150 ppi at 20 × 13.3 in. The pixels do not change; only their spacing does.
Print shops ask for 300 ppi at the final size because below about 200 ppi the pixels start to show as softness or blocking in fine detail. Screens are different: a phone display may be 400 ppi or more, while a desktop monitor is often 100 to 110, which is why an image that looks sharp on screen can print poorly.
PPI and DPI are often used interchangeably. Strictly, PPI belongs to the image and DPI to the printer that reproduces it.
Every paper size at every common resolution is tabulated on paper sizes in pixels.