By BJL's formula (which is more optimistic than many I've seen), a phone sensor will be diffraction-limited around f2-f2.8 (pixels ranging from 1 to 1.4 microns), with most compact cameras (other than large-sensor compacts) limited around f4. Micro 4/3 and large-sensor compacts will be limited somewhere around f5.6-f8, with their 3-4 micron pixels. Larger sensor DSLR/mirrorless cameras will reach their limit between f8 and f11.
By that calculation, only a few lenses are diffraction-limited wide open with the sensors they are most commonly used with. Many compact superzooms are diffraction-limited, with perhaps the most egregious example being the Nikon Coolpix P1000 (1.4 micron pixels and an f8 lens!). A few inexpensive Micro 4/3 lenses may be diffraction-limited wide-open on the 20 MP sensor (there are several with f6.3 maximum apertures on the telephoto end). You might see diffraction wide-open on an APS-C or high-resolution full-frame DSLR with certain lens/teleconverter combinations, but not with any lens used alone.
I've seen visible evidence of diffraction (in tests, not so much in my own images) wider than that by a stop or so. Absent diffraction, a lens would tend to sharpen up as it gets stopped down, no? Most lenses on 40+ MP full-frame cameras are clearly sharpest at f5.6, beginning to soften by f8 - really high performance lenses are equally sharp from some wider aperture to f5.6, but they too soften a bit at f8. The softening at f8 doesn't show up on 24 MP FF cameras, but it does on 24 MP APS-C.