You may have better luck in the search if you change up the terms. In English, at least, "checkers" are a pattern with alternating colors, like a checkers/chess board or a racing flag. What you're looking for, from the example image you posted, is a tutorial on painting
quilted cloth. The desired effect is giving the illusion of patterned texture, not color.
Essentially, you'll need to lay down the lines of the stitching, then shade/highlight each of the resulting diamonds, individually, taking into account both its slightly puffy shape and its facing relative to the assumed light source. This image conveys the idea relatively well:
It's a two-dimensional painting, not a photo of a painted model, but the same concepts apply - there is a general gradient to the shading, based on the shape of the man/horse, but each "cell" of the cloth is further highlighted and shaded, giving the sense of texture. Unfortunately, I wasn't able to find an actual tutorial for painting the effect on miniatures.