3D model from blueprints / dimensions, etc. in Blender
3D model from references in Blender
Retopo & Optimization for game engine
Texturing in Blender and(or) Substance Painter
Rigging and posing the model
Rendering in Blender (Cycles or Eevee), other options can be discussed
Compositing in Blender, AE, or Photoshop